<%@ page import="zyh.servlet.DbDao" %>
<%@ page import="java.sql.ResultSet" %><%--
  Created by IntelliJ IDEA.
  User: yue
  Date: 2018/4/23
  Time: 20:15
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户在线信息</title>
</head>
<body>
在线用户：
<table width="400" border="1" >
    <%
        DbDao dd = new DbDao("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/1613580003",
                "root", "123456");
        ResultSet rs = dd.query("select * from online_inf", false);
        while (rs.next())
        {%>
        <tr>
            <td><%=rs.getString(1)%>
            <td><%=rs.getString(2)%>
            <td><%=rs.getString(3)%>
            <td><%=rs.getString(4)%>
         </tr>
    <%}
    %>
</table>
</body>
</html>
